﻿-- aspnet_SchemaVersions
INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('common', 1, 1)

INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('health monitoring', 1, 1)

INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('membership', 1, 1)

INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('personalization', 1, 1)

INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('profile', 1, 1)

INSERT INTO aspnet_SchemaVersions
(Feature, CompatibleSchemaVersion, IsCurrentVersion)
VALUES
('role manager', 1, 1)

-- COMPONENTS
SET IDENTITY_INSERT dbo.boogaloo_component_tbl ON
GO

INSERT INTO boogaloo_component_tbl
(component_id, name, manages_node)
VALUES
(1, 'Core', 1)

SET IDENTITY_INSERT dbo.boogaloo_component_tbl OFF
GO



SET IDENTITY_INSERT dbo.boogaloo_childsort_type ON
GO

-- CHILD SORTS
INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(1, 'Publish date (descending)', 1) 

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(2, 'Publish date (ascending)', 2)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(3, 'Menu item text (ascending)', 3)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(4, 'Menu item text (descending)', 4)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(5, 'Page link text (ascending)', 5)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(6, 'Page link text (descending)', 6)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(7, 'Manual sort - new nodes inserted at beginning', 7)

INSERT INTO boogaloo_childsort_type
(child_sort_type_id, Name, sort_order)
VALUES
(8, 'Manual sort - new nodes inserted at end', 8)

SET IDENTITY_INSERT dbo.boogaloo_childsort_type OFF
GO 



SET IDENTITY_INSERT dbo.boogaloo_node_type ON
GO
-- NODE TYPE
INSERT INTO boogaloo_node_type
(node_type_id, Name, Description, hidden, sort_order)
VALUES
(1, 'Webpage', 'Webpage - most common node type', 0, 1)

INSERT INTO boogaloo_node_type
(node_type_id, Name, Description, hidden, sort_order)
VALUES
(2, 'Folder', 'Folder - used to organize sitemap', 0, 2)


INSERT INTO boogaloo_node_type
(node_type_id, Name, Description, hidden, sort_order)
VALUES
(3, 'External Url', 'A link to a web resource not managed by Boogaloo. (Note this could be another web resource within the web root).', 0, 4)

INSERT INTO boogaloo_node_type
(node_type_id, Name, Description, hidden, sort_order)
VALUES
(4, 'Local File', 'A link to a web resource not managed by Boogaloo but within the same IIS web (virtual path).  This is useful for linking files to download or shortcuts to other pages.', 0, 3)

SET IDENTITY_INSERT dbo.boogaloo_node_type OFF
GO